AddChart(CellRange[],Type,Int32,Int32,Int32,Int32,ChartViewType,Boolean) Method

In This Topic

Adds a chart to the SheetView. The chart is aligned in the center of the SheetView.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function AddChart( _
   ByVal cellRanges() As CellRange, _
   ByVal seriesType As Type, _
   ByVal width As Integer, _
   ByVal height As Integer, _
   ByVal x As Integer, _
   ByVal y As Integer, _
   ByVal viewType As ChartViewType, _
   ByVal showLegend As Boolean _
) As SpreadChart

'Usage
 
Dim instance As SheetView
Dim cellRanges() As CellRange
Dim seriesType As Type
Dim width As Integer
Dim height As Integer
Dim x As Integer
Dim y As Integer
Dim viewType As ChartViewType
Dim showLegend As Boolean
Dim value As SpreadChart
 
value = instance.AddChart(cellRanges, seriesType, width, height, x, y, viewType, showLegend)

public SpreadChart AddChart( 
   CellRange[] cellRanges,
   Type seriesType,
   int width,
   int height,
   int x,
   int y,
   ChartViewType viewType,
   bool showLegend
)

Parameters

cellRanges: Multiple cell ranges that are used to create data for the chart.
seriesType: Indicates which chart type is added.
width: Width of the chart.
height: Height of the chart.
x: The X position.
y: The Y position.
viewType: Type of the view.
showLegend: if set to true the new chart has a default legend area; otherwise, there is no legend area.

Return Value

The newly created instance of the chart.

Remarks

The first cell range in the cellRange array is used to generate the chart. The other cell ranges are used to generate several series and the series are added to the current chart plot area. The seriesType parameter indicates which type of chart will be added. The chartWidth and chartHeight parameters specify the size (width and height) of the chart. The absolute position is specified by the x and y parameters. The ChartViewType parameter is the view type of the chart (2D or 3D). The showLegend parameter indicates whether to show a default legend area in the chart.

Example

This example creates a chart control.

C#
Visual Basic

Reference

SheetView Class
SheetView Members
Overload List